Experimental BBS Explossion 3/Experimental BBS Explossion III.iso/database/video.zip/VIDEO.DOC

Text File | 1993-10-25 | 26KB | 707 lines

CVB Video Control System  Ver 1.10
(c)  COPYRIGHT,  1993  CVB Software
Written By: Bill Staab































TABLE OF CONTENTS

Introduction................................ 3
Hardware Requirements....................... 3
Installation................................ 3
Setup....................................... 3
Membership File............................. 5
Inventory File.............................. 7
UPC Items File.............................. 9
Transactions Menu........................... 10
Rental Returns.............................. 12
Report Generator............................ 12
Accounting.................................. 13
End of Day Reports.......................... 14
Date & Time................................. 14
Print Bar Codes............................. 14
Exiting the Program......................... 15
Warranty.................................... 15
Registration................................ 16





INTRODUCTION

CVB Video Control System is a full featured video rental and sales store
point of sale and accounting system.  If gives the user full control and
tracking of all rental and sales items and accounting.  It prints reports
for all types of accounting and tracking.  It includes multiple password
control for different levels of access.  The CVB Video Control System is
bar-code capable  for reading bar-codes on membership cards, Video tapes
and UPC bar-codes on sales items.

HARDWARE REQUIREMENTS

The CVB Video Control System is designed to run on any IBM or compatible
machine having at least 640 K of ram and  a hard drive.  The program was
written and tested using the EZ Barcode wand scanner.  A printer is
required for printing of customer receipts and accounting reports.  The
program is also mouse compatible.

INSTALLATION

Installation is very quick and painless.  Make a directory on your hard
drive i.e. C:\Video or whatever you choose.  Copy the files video.exe and
isamrepr.exe into the directory.  Start the program Video.exe and it will
automatically build two DataBase files.  Video.mdb and acct.mdb.  Video.mdb
is used to store your inventory and rental items along with your setup
information.  Acct.mdb is used to record your accounting information.
The file isamrepr.exe is used to repair a DataBase in the case that it
becomes corrupt from loss of power or some other reason.

SETUP

The first time CVB Video Control System is run it will go to the Options
Setup Screen for initial setup.  The options setup screen includes the
following options.


Company Information:

Company Name, Address, City, State, Zip and phone number.  This information
is transformed as a heading for all reports and sales or rental receipts.

Passwords:

The CVB Video Control System has the option of setting password control
for the following menu option screens.  Transactions, Membership file,
Inventory Files, Rental Returns, Report Generator, Accounting, End of Day
Reports, and the Options Setup Screen.  Video is the default password set
for all screens.  The Manager has the option of setting different passwords
for any of the screens or leaving the option blank.  If the option password
has any value other than blank the user will be prompted to enter the
password prior to any access to that screen.  If the option is left blank
CVB Video Control System will not display the password screen and go
directly to the screen selected.

Tax Codes:

The CVB Video Control System is set up for three different Tax codes.
These codes are to be set up as a decimal number.  If you have a 6% sales
tax it would be entered into setup as .06 a 10% tax would be .10 et.
If a .00 is set it would be a tax free purchase.  The tax code for each
member is set at the membership screen and can be set different for
different members.

Price Codes:

The CVB Video Control System has the capability of using 5 different
Rental Price Code's and 5 different Late Charge Code's.  The price and
late charge codes are set in the inventory menu.  You can use any
combination of codes for rental pricing and late charges.  Sales items
price coding is set in the inventory menu on an item to item basis.

Rental Due Codes:

The CVB Video Control System gives you a choice of 3 different due days.
This item is used to set the number of calendar days a rental item is
allowed out before late charges are assessed.  the late charge code is
set on rental items through the inventory screen.

Print Setup:

The CVB Video Control System will allow up to 10 lines of text that
will appear at the bottom of the invoice for comments, signatures or
anything you want printed at the bottom of the invoice.  The combination
of the ALT key and the F1 key are used to access the Print Setup screen.



MEMBERSHIP FILE

The membership screen is used to add and edit the customer base.  The
following is a breakdown of the information in the customer screen.

Customer #:

The customer is assigned a customer number by the system.  The customer
numbering system will allow up to 1,000,000 customers to be added to the
DataBase.  The customer number is a 7 digit number starting with the
number 9.  The first customer will have the number 9000001 assigned
to it and as new customers are added the system will automatically
assign the next number.

Name:

This is where the customer name is entered.  The first and last names
are to be entered into this field.  It is recommended that you enter
the last name first.  If you print a report by name order it will then
come out in alphabetical order by last name i.e. Doe, John.

Address:

This  is used to enter the customer street address.  It is printed on the
invoice and mailing label features of the program.

City:

This is for the customer City.  This will be displayed on the invoice
and mailing label features of the program.

State:

This area is to enter the customer State.  It is printed on the invoice
and mailing label features of the program.

Zip:

This is the customers postal Zip code.  It is printed on the invoice
and mailing label features of the program.

Phone:

Customer Phone Number for reference and receipt.

ID #:

This area is an optional area that can be used to record the type or
number of identification of the customer.  It is used for your reference
only.

Comments:

This is an optional Text line for your reference and not used by the
program.

Membership Date:

This is the date that the individual is entered into the system.
The system will default to the system date unless changed by the operator.

Customer Tax Code:

This area is used to enter the tax rate that the customer must pay for
rentals, sales items and late charges.  This rate corresponds with the
choices in the options setup menu.  If a customer is tax free the option
must be set to .00 in the options setup.

# of Past Rentals:

This item is a running count of the total number of rentals a customer
has rented since his or her membership was started.  This item cannot
be set or changed by the operator, but is controlled entirely by the
program and is for your information only.

Last Rental Date:

The last date a customer checked out a rental item is entered in this
field.  This Item is updated by the system and cannot be manually changed
by the operator.

Total Dollars Spent:

This is a reference field that is kept by the system and show the revenue
taken in from that particular customer.  This field cannot be edited or
changed by the operator.

Items Out:

This window will show at any time all items that are currently in the
possession of the member.  It lists the Item #, description of the item
and the date the item is due to be returned.  This field cannot be
manually changed by the operator through this screen.  Items can only
be added in the transaction screen and removed through the rental return
screen.

Customer Number Search;

The customer number search screen is accessed by using the ALT and F1
key combination.  When depressed the Items #: field is highlighted and
the operator enters the 7 digit customer number or scans the customer
membership card.  The system will then pull up the customer record, if
it exists.  At this time the operator can change or edit the permissible
fields.

Customer Name Search:

The customer name search screen is accessed by using the ALT and F2 key
combination.  When depressed the Name field is highlighted and the operator
enters the customer  name for the DataBase to search.  The system will
then pull up the customer record, if it exists.  At this time the operator
can change or edit the permissible fields.


INVENTORY FILE


The inventory screen is used to add and edit all inventory (rental and sales)
items.  The following is a list of the item on the inventory screen.

Item #:

The item number is used for rental items, it is a system generated number
that is 7 digits in length with the first number being a 1.  The system is
capable of assigning 1,000,000 different rental item numbers.  The number
is automatically assigned by the system which searches the DataBase and
assigns the next available number.

Title:

The title area is used to enter the title of the rental item and is displayed
on the invoice.

Staring:

The CVB Video Control System will allow up to 4 different stars of the
movie to be listed in the fields ( 1 to each line).

Yr. Made:

This field is a display field that is displayed when a list of rental
inventory is printed.  It is for reference by the customer.

Rating:

This field is a display field that is displayed when a list of rental
inventory is printed.  It is for reference by the customer.

Rental Code:

This entry will always be the letter A thru E.  The Rental Code will
determine the amount that is charged to the customer for the rental.
The Inventory window will display a popup window for you to select the
amount corresponding with the entries in the options setup.

Late Fee Code:

This entry will always be the letter A thru E.  The Late Fee Code
will determine the amount that is charged to the customer for late
rental return.  The Inventory window will display a popup window for
you to select the amount corresponding with the entries in the options
setup.  Late charges are automatically added to the customers account
and you will be flagged with the amount prior to any new sales or items
being invoiced.

Days Out Code:

The Days Out Code must be entered as Letter A thru C.  This code will
be displayed by a popup window and will let you select the number of
days the item is to remain out for a normal rental period.

Date Purchased:

This is a display entry item that shows the date the item was purchased
for rental.

Cost:

This is used to show the cost of the rental item when purchased.

Times Rented:

This field gives a running total of how many times the item has been rented.
The field is controlled by the system and can not be changed or deleted by
the operator.

Total Revenue:

This field will display a total dollar amount that the item has brought
in in rental charges since it was put in service.  The total revenue field
is controlled by the system and can not be changed or edited by the operator.

Checked Out to Customer #:

This field will have the customer number of the customer that currently has
the item out on rental.  If the item is not currently out the system will
display the word "IN".  This field is controlled by the system and is
changed only by the invoice screen (out) or the Return Rental screen (in).

Customer Phone:

This field lists the phone number of the customer that the rental item
is checked out to.

Customer Name:

This field lists the name of the customer that the rental item is checked
out to.

Date out:

This field gives the date the customer checked out the item.

Date Due:

This is the date that the customer is scheduled to return the rental item:

# Search:

To search a rental item number for information or editing the ALT+F1 key
are used.  When depressed the Item # field is highlighted.  You can scan
the code or hand enter the item number at this time.  Any operator entered
field can be edited at this time.

Title Search:

If the operator is unsure of an item number it can be searched using the
title by depressing the ALT+F2 key.  This combination will highlight the
Title entry field for your search.


UPC ITEMS FILE


The UPC items file is used to enter the UPC code and appropriate information
for sales items.  There is no preset numbering system.  The UPC code that
is printed on most products today can be scanned with the bar-code reader
or hand entered or you can assign a number of your own in this screen.
The ALT+F3 keys from the Inventory Menu are used to access the UPC items
screen . The following is a listing of the fields in the UPC item file.

UPC #:
In this area the operator would scan or enter the number he wishes to
look up for editing or adding inventory.  If the number is not found
the system presumes it is a new number to be added.

Description:

This field is a text field for the item description to be printed on
invoices.

Cost:

This field is to show the wholesale cost of the item.

Retail Price:

The retail price section is for the dollar amount that the item is to
be sold for.  This is the price that appears on the Invoice.  The tax
rate of the customer (if any) will be added based on this price.

Qty on Hand:

This is the area where the operator enters incoming merchandise.  The
machine will deduct the item quantity automatically as it is invoiced.

Total Sold:

This area shows the total quantity of the item that has been sold since
the item was added to the inventory.  This field can not be changed or
edited by the operator.


TRANSACTIONS MENU


The transaction menu is used to enter your rental and sales information.
It has two look up fields (Star Search and Title Search).  The following
are the fields used by the operator  on the transaction screen.

Customer #:

This field is used to scan or enter a customers ID number.  When the
system finds the information it will automatically enter the customer
name, address, city, state, zip and phone number on the invoice.  These
fields can only be edited or changed by using the Membership file screen.
If a cash sale is to be made you can just hit enter without entering a
number.  Be sure you go to the membership file and add a tax code for
local sales tax using the name search for Cash Sale to insure proper
tax charges.

Item Number:

The item number field  is used to scan or enter the rental or sales item
number for sales or rental transaction.  The description, due date and
price are automatically entered by the system.  These items are set using
the information furnished by the operator in the inventory file area.
The Sub Total, Tax and total areas are updated automatically by the
system as each entry is entered.  The CVB Video Control System will
allow up to ten sales or rental item on a single invoice.

Print Invoice:

When all items are entered the Letter "P" is used to activate the amount
tendered popup screen.  If return is hit without entering an amount the
system defaults to the exact amount.  You then have one more chance to
cancel and go back to the invoice.  If all is OK just hit your enter key
to print the invoice.  The invoice screen will then clear after all rental
and sales information is recorded and updated.

Star Search:

The Star Search field was added onto the invoice screen so that the operator
would not have to return to the main menu and then to another screen to look
up information to help a customer find a particular rental with a certain
star in it.  When the operator hit the key combination of ALT+F1 a list
screen appears and highlights the entry area where the name is entered.
The system will automatically search the entire DataBase and list all
rentals with the matching name in any of the four star field that were
in the inventory entry area.  The system will give the Item #, Title
and the date due or IN if the item is not checked out.

Title Search:

The Title Search field was added onto the invoice screen so that
the operator would not have to return to the main menu and then to
another screen to look up information to help a customer find out if
a particular Title is in house or when one is due back.  When the
operator hit the key combination of ALT+F2 a list screen appears and
highlights the entry area where the title is entered.  The system will
automatically search the entire DataBase and list all rentals with the
matching title.  If there are more than one copy of a particular rental
all copies will be listed.  The system will give the Item #, Title and
the date due or IN if the item is not checked out.


RENTAL RETURNS


The Rental Return Screen has only one field and that is used to enter
or scan the bar-code of the item being returned.  The system will
automatically check to see if  the item was returned before the due
date.  If the item is late the system will calculate the late charge
according to the amount set in the late charges field of the inventory
file and add the amount to the account of the customer.  The system will
then flag the operator that an amount past due is owed from prior rentals
the next time the customer makes a purchase or rents an item.


REPORT GENERATOR


The report generator sill provide eight different type of reports and
print label for mail outs to your customers.  All reports have the
Company information heading supplied in the Options setup.  The following
is a list of reports generated by the report generator.

Past Due Rentals(Item # Order):

This report gives a listing in item # order of all rentals that are past due.
It includes the item #, Rental Title, Due Date and Customer Number of the
customer that has possession.

Past Due Rentals(Customer # Order):

This report gives a listing in customer # order all rentals that are past
due.  It includes the item #, Rental Title, Due Date and Customer Number
of the customer that has possession.

Past Due Rentals(Customer Name Order):

This report gives a listing in customer name order all rentals that are
past due.  It includes the item #, Customer Name, Phone, Due Date and
Item # .

Late Fee Report:

The late fee report is a listing by customer # all customers that have
a balance owed on their account.  The report lists the Customer #,
Customer Name, Phone and the dollar amount that is owed.

Rentals Out Report:

The rentals out report gives a listing of all rental items that are out,
both late and current.  The report is in item # order and lists the item #,
title, due date and member # that it is checked out to.

Rental Inventory List:

The rental inventory list gives a report of the entire rental library in
title order.  It gives the item #, title, rating, year made and the rental
price code.

Sales Inventory List:

The sales inventory list will give a listing of all items in the DataBase
that are sales items.  The listing is in UPC # order and lists the UPC #,
Description, Quantity on hand and # of items sold.

Membership List:

The membership list is a printout of all members in the DataBase in name
order.  The list provides the Cust #, Name, Phone # and date of membership.

Membership Labels:

The membership label selection will print the name, address, city, state
and zip code on standard 3 1/2" by 15/16" computer labels for mailing
purposes.  It will make one label for each member in the membership
database.


ACCOUNTING


The accounting menu is a system controlled menu.  The only control
the operator has is to clear totals.  The accounting menu gives a
running total on a daily, monthly and yearly basis.  The figures are
added at the time the invoice is printed and is up to date at any given
time.  The accounting menu gives you the total Rentals (Taxable), Rentals
(NonTaxable), Sales (Taxable), Sales (Non-Taxable, Late Fees Collected,
Sales Tax Collected and the Totals of all the colomns.  The F1 Key will
print a report giving all the information in the accounting screen.
The F3 key will clear and reset all the monthly totals to 0.  The F4
key will clear the yearly totals.  As a saftey precaution you will be
prompted prior to any totals being cleared.  Make sure you print all
totals before they are cleared as they can not be retreived.


END OF DAY REPORTS


The end of day reports menu is a system controlled menu.  The only
control the operator has is to clear totals.  The end of day reports
menu gives a running total on a daily basis only.  The figures are
added at the time the invoice is printed and is up to date at any
given time.  The end of day reports menu gives you the total Rentals
(Taxable), Rentals (NonTaxable), Sales (Taxable), Sales (Non-Taxable,
Late Fees Collected, Sales Tax Collected and the Totals of all the
colomns.  The F1 Key will print a report giving all the information
on the end of day reports screen.  The F2 key will clear and reset
all the daily  totals to 0.  As a saftey precaution you will be
prompted prior to any totals being cleared.  Make sure you print all
totals before they are cleared as they can not be retreived.


DATE AND TIME


The date and time window was added for machines that do not have a
built in clock.  When entering the date and time window the operator
will first be prompted to enter the system date.  The date MUST be
entered as (mm-dd-yyyy).  If the date was September 7, 1993 it would
be entered as 08-22-1993.  No other format will be accepted.  The time
format is (hh:mm:ss).  The system also uses a 24 hour clock.  If the
time was  8:15 PM it would be enteres as 20:15:00.


PRINT BAR CODES


A barcode label printer has been included for those not having a way
to print barcodes.  The barcode print feature will print barcode numbers
only.  The barcode print feature will also allow you to print more than
one barcode.  If the starting mumber is entered and the ending number is
left blank (or is the same number) only one barcode will be printed.
If a starting number is ended the system will print the starting number
and all numbers up to and including the ending number.  The barcode
printer spacing is set up to use standard    3 1/2 " by 15/16" labels.



EXITING THE PROGRAM


To exit the program go to the exit program selection on the main menu.
If the operator turns the power off while the program is running or
if there is a loss of power the database files may become corrupt.
I have included a file called ISAMREPR.exe with the program to repair
the database in the event this happens.  I cannot guarantee that it will
repair all databases but it has worked on all the ones I have used it with.
The safe way is to be sure the operator is properly instructed to exit
the program prior to turning off the power.  A battery backup system
to prevent power loss due to weather and other unforseen power losses
is strongly reccomended.


WARRANTY


This program is provided "AS IS" without warranty of any kind, either
expressed or implied.  CVB Software does not warrant that the program
will meet the reauirement of your perticular business or that the
program will be error free.






REGISTRATION


CVB Video Control System is distributed as shareware.
Shareware is commercial software distributed in an unconventional way.
Microcomputers copy information very easily.  Instead of trying to
frustrate this through copy protection, shareware takes advantage of
it to reach as many users as possible at the lowest cost.  Anyone may
copy a shareware program and distribute it to whomever they desire,
provided they do not charge a fee or alter it.
However , unlike conventional distribution, shareware allows you to evaluate
the product before you decide to purchase it.  If you are still using a
shareware product after several weeks it must be worth the money, so
register it.

The cost of registration of the CVB Video Control System is 90.00.
The benifit of registering is that you will receive a printed manual,
the most current copy of the software and phone support.

CVB Software
c/o Bill Staab
1157 280th Ave
Hays, Kansas  67601
[phone]


Order Form
Name_____________________________________________________________
Company Name ____________________________________________________
Address _________________________________________________________
City, State,Zip__________________________________________________
Phone ___________________________________________________________

Kansas Residents add 6% Sales Tax: